![]() |
![]() |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
To access the contents, click the chapter and section titles.
Oracle Performance Tuning and Optimization
SQLWindows from GuptaGuptas SQLWindows is another very popular application development tool. As with the other tools, SQLWindows guides you through the development of an application using its QuickForms wizard. Using this tool, you can easily and quickly develop a usable application. SQLWindows comes with ODBC drivers and recommends using them as the primary method of connection. The SQLWindows tool comes with a forms generator you can use to quickly deploy applications (see Figure 35.17). The forms tool is very easy to use and can have you building and running applications quickly.
Although SQLWindows uses a scripting language, it is possible to use user-defined functions. To define your own functions or SQL statements, choose the object you want to modify from the main window. SQLWindows uses an outline presentation for developing the applications. By double-clicking the object, as shown in Figure 35.18, you eventually display the Message Actions.
Adding a function to the Message Actions line allows you to override the default action and apply your own action (see Figure 35.19). At this point, you can define your own function or use a predefined SQLWindows function to optimize your SQL statements. As is true with Oracle Power Objects, it is difficult to modify the SQL statements in SQLWindows, and you dont have access to the SQL statements that SQLWindows uses by default.
As with other tools described in this chapter, you can run in interpreted mode for debugging and development, but you can compile the application for deployment. In this manner, you can quickly develop and prototype applications, but your deployed applications are more efficient and faster because they are compiled. For developing reports, SQLWindows comes with a report design tool called ReportWindows (see Figure 35.20). ReportWindows allows you to build custom reports very quickly.
As you have seen, SQLWindows has a slightly different way of looking at application development: it uses an outline format to develop the application. Even so, both of the tools in SQLWindows are very good. PowerBuilder from PowersoftPowerBuilder from Powersoft is by far the most popular application development tool. PowerBuilder was among the first to introduce these types of products. PowerBuilder comes with ODBC drivers and native drivers that allow you to connect to SQL*Net directly. It is much more efficient to build native Oracle applications than it is to use ODBC because ODBC essentially takes the calls to it and translates them to SQL*Net calls, causing unnecessary overhead. To build PowerBuilder forms, you use the DataWindow to describe the columns you want to use in the form. During this development process, the SQL statements you will be using to query this table are automatically available to you by clicking the Syntax tab (see Figure 35.21).
In this manner, you have instantaneous and simple control over the structure of your SQL statements. If you are working with a PowerBuilder application, you get to this window by clicking the DataWindow tool icon on the main toolbar (see Figure 35.22).
Once in the DataWindow, you can optimize and change the SQL statements to suit your needs. As mentioned earlier in the chapter, application development tools have evolved over the years so that now their SQL statements and the GUI are efficient and perform well. In most cases, there is no need to alter these SQL statements or the application to improve performance. SummaryTo rapidly deploy applications in a variety of different environments, it is often more efficient to use GUI application development tools instead of writing applications from scratch. As you have seen in this chapter, there are several excellent third-party and Oracle tools available for application development. The chapter described some of these tools and explained how to modify the SQL statements generated by the tools to take advantage of optimization techniques. You should now have an idea about how some application development tools work and how you can optimize the SQL code the tools generate. When you add the information in this chapter to the other chapters in Part V, Tuning the Client, you are well on your way to developing an optimized application and client system. The next chapter looks at some ways to improve the overall performance of your configuration by taking advantage of middleware. By distributing the load among several machines, you may get better overall performance than with one large server.
|
![]() |
Products | Contact Us | About Us | Privacy | Ad Info | Home
Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc. All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited. |